/**
 * Copyright (c) 2013-Now http://jeesite.com All rights reserved.
 */
package com.jeesite.modules.fty.entity;

import com.jeesite.common.entity.Extend;
import com.jeesite.common.lang.DateUtils;
import com.jeesite.common.mybatis.annotation.JoinTable;
import com.jeesite.modules.sys.entity.Employee;
import org.hibernate.validator.constraints.Length;

import com.jeesite.common.entity.DataEntity;
import com.jeesite.common.mybatis.annotation.Column;
import com.jeesite.common.mybatis.annotation.Table;
import com.jeesite.common.mybatis.mapper.query.QueryType;
import org.hibernate.validator.constraints.NotBlank;
import org.hibernate.validator.constraints.NotEmpty;

import javax.validation.constraints.Min;
import javax.validation.constraints.Pattern;
import java.util.Date;

/**
 * 合同表Entity
 * @author chensk
 * @version 2018-04-18
 */
@Table(name="${_prefix}fty_sel_contract", alias="a", columns={
		@Column(name="contract_code", attrName="contractCode", label="主键", isPK=true),
		@Column(name="c_number", attrName="cNumber", label="合同编号"),
		@Column(name="a_name", attrName="aName", label="卖方", queryType=QueryType.LIKE),
		@Column(name="a_legal", attrName="aLegal", label="卖方法人"),
		@Column(name="a_contry", attrName="aContry", label="甲方国家"),
		@Column(name="a_address", attrName="aAddress", label="a_address"),
		@Column(name="a_idcard", attrName="aIdcard", label="甲方身份证"),
		@Column(name="a_postcode", attrName="aPostcode", label="甲方邮政编码"),
		@Column(name="a_phone", attrName="aPhone", label="甲方手机"),
		@Column(name="a_email", attrName="aEmail", label="甲方email"),
		@Column(name="a_p_name", attrName="aPName", label="甲方代理人名字", queryType=QueryType.LIKE),
		@Column(name="a_p_contry", attrName="aPContry", label="甲方代理人国家"),
		@Column(name="a_p_idcard", attrName="aPIdcard", label="甲方代理人身份证"),
		@Column(name="a_p_address", attrName="aPAddress", label="甲方代理人地址"),
		@Column(name="a_p_poscode", attrName="aPPoscode", label="甲方邮政编码"),
		@Column(name="a_p_phone", attrName="aPPhone", label="甲方代理人手机"),
		@Column(name="a_p_email", attrName="aPEmail", label="甲方代理人email"),
		@Column(name="b_name", attrName="bName", label="乙方名称", queryType=QueryType.LIKE),
		@Column(name="b_legal", attrName="bLegal", label="乙方法人"),
		@Column(name="b_contry", attrName="bContry", label="乙方国家"),
		@Column(name="b_idcard", attrName="bIdcard", label="乙方身份证"),
		@Column(name="b_address", attrName="bAddress", label="乙方地址"),
		@Column(name="b_postcode", attrName="bPostcode", label="乙方邮政编码"),
		@Column(name="b_phone", attrName="bPhone", label="乙方手机"),
		@Column(name="b_email", attrName="bEmail", label="乙方email"),
		@Column(name="b_p_name", attrName="bPName", label="乙方代理人名字", queryType=QueryType.LIKE),
		@Column(name="b_p_contry", attrName="bPContry", label="乙方代理人国家"),
		@Column(name="b_p_idcard", attrName="bPIdcard", label="乙方代理人身份证"),
		@Column(name="b_p_address", attrName="bPAddress", label="乙方代理人地址"),
		@Column(name="b_p_postcode", attrName="bPPostcode", label="乙方代理人邮编"),
		@Column(name="b_p_email", attrName="bPEmail", label="乙方代理人邮箱"),
		@Column(name="a_type", attrName="aType", label="甲方类型"),
		@Column(name="a_card_type", attrName="aCardType", label="甲方卡类型"),
		@Column(name="a_p_card_type", attrName="aPCardType", label="甲方证件类型"),
		@Column(name="b_card_type", attrName="bCardType", label="乙证件类型"),
		@Column(name="b_p_type", attrName="bPType", label="乙方证件类型"),
		@Column(name="c_name", attrName="cName", label="丙方名字", queryType=QueryType.LIKE),
		@Column(name="c_legal", attrName="cLegal", label="丙方法人"),
		@Column(name="c_address", attrName="cAddress", label="丙方地址"),
		@Column(name="c_postcode", attrName="cPostcode", label="丙方邮编"),
		@Column(name="c_busi_code", attrName="cBusiCode", label="丙方营业执照号"),
		@Column(name="c_record_number", attrName="cRecordNumber", label="备案证号"),
		@Column(name="c_p_id_card", attrName="cPIdCard", label="丙身份证号"),
		@Column(name="c_bro_cer", attrName="cBroCer", label="经纪人资格号"),
		@Column(name="c_phone", attrName="cPhone", label="丙手机号码"),
		@Column(name="c_ts_phone", attrName="cTsPhone", label="丙方投诉号码"),
		@Column(name="h_account_name", attrName="hAccountName", label="房屋户名", queryType=QueryType.LIKE),
		@Column(name="h_address", attrName="hAddress", label="房屋地址"),
		@Column(name="h_allplies", attrName="hAllplies", label="房屋总层数"),
		@Column(name="h_plie", attrName="hPlie", label="房屋所在层"),
		@Column(name="h_useage", attrName="hUseage", label="房屋年限"),
		@Column(name="h_year", attrName="hYear", label="h_year"),
		@Column(name="h_finish", attrName="hFinish", label="房屋竣工时间"),
		@Column(name="h_struts", attrName="hStruts", label="房屋结构"),
		@Column(name="h_area", attrName="hArea", label="建筑面积"),
		@Column(name="h_decoration", attrName="hDecoration", label="装修情况"),
		@Column(name="h_others", attrName="hOthers", label="其他设施"),
		@Column(name="h_yy_type", attrName="hYyType", label="附属房独有还是共有"),
		@Column(name="h_fss", attrName="hFss", label="附属房种类"),
		@Column(name="h_use_type", attrName="hUseType", label="附属房面积种类", comment="附属房面积种类(使用面积/建筑面积)"),
		@Column(name="h_use_area", attrName="hUseArea", label="附属房面积大小"),
		@Column(name="h_others_status", attrName="hOthersStatus", label="房屋限制使用权情况说明"),
		@Column(name="h_gz_sm", attrName="hGzSm", label="房屋改造情况说明"),
		@Column(name="h_g_landholder", attrName="hGLandholder", label="国有土地使用权人"),
		@Column(name="h_g_warrant_number", attrName="hGWarrantNumber", label="国有土地权证号"),
		@Column(name="h_warrant_number", attrName="hWarrantNumber", label="国有土地权证号"),
		@Column(name="dk_fs", attrName="dkFs", label="贷款方式"),

		@Column(name="h_g_land_type", attrName="hGLandType", label="国有土地使用权类型"),
		@Column(name="h_g_land_others", attrName="hGLandOthers", label="国有土地其他情况类型"),
		@Column(name="h_money_all", attrName="hMoneyAll", label="房屋总价"),
		@Column(name="h_money_first", attrName="hMoneyFirst", label="定金"),
		@Column(name="h_time_second", attrName="hTimeSecond", label="首付日期"),
		@Column(name="h_money_second", attrName="hMoneySecond", label="首付价格"),
		@Column(name="h_money_third", attrName="hMoneyThird", label="第二次支付房款"),
		@Column(name="h_time_third", attrName="hTimeThird", label="第二次支付时间"),
		@Column(name="h_money_four", attrName="hMoneyFour", label="余款"),
		@Column(name="h_time_four", attrName="hTimeFour", label="余款时间"),
		@Column(name="h_money_five", attrName="hMoneyFive", label="按揭余款"),
		@Column(name="money_broke", attrName="moneyBroke", label="未履行方每日承担"),
		@Column(name="money_broke_day", attrName="moneyBrokeDay", label="违约约定天数"),
		@Column(name="a_manage_fee", attrName="aManageFee", label="卖方支付居间服务费"),
		@Column(name="b_manage_fee", attrName="bManageFee", label="买方支付居间服务费"),
		@Column(name="b_other_fee", attrName="bOtherFee", label="乙方其他费用"),
		@Column(name="h_attached", attrName="hAttached", label="房屋附属品"),
		@Column(name="pay_way", attrName="payWay", label="物业管理费用付款约定", comment="物业管理费用付款约定(1甲2乙)"),
		@Column(name="c_precent", attrName="cPrecent", label="丙方违约赔偿百分比"),
		@Column(name="traspaso_day", attrName="traspasoDay", label="过户最晚时间"),
		@Column(name="prosecute_way", attrName="prosecuteWay", label="起诉单位"),
		@Column(name="remark", attrName="remark", label="remark"),
		@Column(name="contract_date", attrName="contractDate", label="合同生成日期"),
		@Column(name="attach", attrName="attach", label="附件清单"),
		@Column(name="addedvalue_part", attrName="addedvaluePart", label="增值税承担方"),
		@Column(name="persontax_part", attrName="persontaxPart", label="个税承担方"),
		@Column(name="land_tax", attrName="landTax", label="土地拨划税承担方"),
		@Column(name="other_engagements", attrName="otherEngagements", label="其他约定"),
		@Column(name="jf_yd", attrName="jfYd", label="交付约定"),
		@Column(name="jf_date", attrName="jfDate", label="交付时间"),
		@Column(name="c_p_name", attrName="cPName", label="经纪人姓名"),
		@Column(name="c_p_phone", attrName="cPPhone", label="经纪人电话"),
		@Column(name="b_type", attrName="bType", label="经纪人电话"),
		@Column(name="b_p_phone", attrName="bPPhone", label="乙方代理人手机"),
		@Column(name="h_cq_type", attrName="hCqType", label="房屋产权类型"),
		@Column(name="wfjq_fy", attrName="wfjqFy", label="水电无法结清保证金"),
		@Column(name="important_clause", attrName="importantClause", label="费用支付特别声明"),
		@Column(name="use_hd", attrName="useHd", label="是否用于甲方还贷"),
		@Column(name="h_money_house", attrName="hMoneyHouse", label="房屋价款"),
		@Column(name="h_money_decor", attrName="hMoneyDecor", label="装修设施等价款"),
		@Column(name="a_yq_oneday_money", attrName="aYqOneydayMoney", label="过户时甲方逾期一天支付金额"),
		@Column(name="a_wy_money", attrName="aWyMoney", label="过户甲方违约金"),
		@Column(name="b_yq_oneday_money", attrName="bYqOnedayMoney", label="过户时乙方逾期一天支付金额"),
		@Column(name="b_wy_money", attrName="bWyMoney", label="过户乙方违约金"),
		@Column(name="fy_others", attrName="fyOthers", label="其他约定"),


		@Column(name="gf_date", attrName="gfDate", label="权证代办服务费"),

		@Column(name="h_time_five", attrName="hTimeFive", label="过户手续办理时间"),
		@Column(name="fcz_number", attrName="fczNumber", label="房产证本数"),
		@Column(name="td_number", attrName="tdNumber", label="土地使用权本书"),
		@Column(name="bd_number", attrName="bdNumber", label="不动产权本书"),
		@Column(name="qz_number", attrName="qzNumber", label="契证本数"),
		@Column(name="jf_others", attrName="jfOthers", label="其他相关事宜"),
		@Column(name="contract_add", attrName="contractAdd", label="其他相关事宜"),
		@Column(name="qz_fy", attrName="qzFy", label="权证费用"),
		@Column(name="zl_fy", attrName="zlFy", label="资料费用"),
		@Column(name="fj_ys", attrName="fjYs", label="附件页数"),
		@Column(name="h_scdate", attrName="hScdate", label="合同签订日期"),
		@Column(name="f_anjb", attrName="fAnjb", label="按揭代办服务费"),

		@Column(includeEntity=DataEntity.class),
},  joinTable={
		@JoinTable(type= JoinTable.Type.LEFT_JOIN, entity=Employee.class, alias="e",
				on="a.create_by = e.emp_code",
				columns={@Column(name="create_by", 		attrName="createBy", 		label="创建者", isUpdate=false),
						@Column(name="company_code", 		attrName="companyCode", 		label="公司标签", isUpdate=false),
						@Column(name="create_date", 	attrName="createDate", 		label="创建时间", isUpdate=false, isQuery=false),}),
},extWhereKeys="dsfOffice, dsfCompany", orderBy="a.update_date DESC"
)
public class FtySelContract extends DataEntity<FtySelContract> {

	private String importantClause;
	private String hScdate;

	public String getHScdate() {
		return hScdate;
	}

	public void setHScdate(String hScdate) {
		this.hScdate = hScdate;
	}

	public String getImportantClause() {
		return importantClause;
	}

	public void setImportantClause(String importantClause) {
		this.importantClause = importantClause;
	}

	private static final long serialVersionUID = 1L;
	private  String dkFs;

	public String getDkFs() {
		return dkFs;
	}

	public void setDkFs(String dkFs) {
		this.dkFs = dkFs;
	}
	private String fyOthers;

	public String getFyOthers() {
		return fyOthers;
	}

	public void setFyOthers(String fyOthers) {
		this.fyOthers = fyOthers;
	}

	private String contractCode;		// 主键
	private String cNumber;		// 合同编号


	private String qzFy;		// 合同编号

	private String zlFy;		// 合同编号

	public String getQzFy() {
		return qzFy;
	}

	public void setQzFy(String qzFy) {
		this.qzFy = qzFy;
	}

	public String getZlFy() {
		return zlFy;
	}

	public void setZlFy(String zlFy) {
		this.zlFy = zlFy;
	}
	private String fjYs;

	public String getFjYs() {
		return fjYs;
	}

	public void setFjYs(String fjYs) {
		this.fjYs = fjYs;
	}

	private String aName;		// 卖方
	private String aLegal;		// 卖方法人
	private String aContry;		// 甲方国家
	private String aAddress;		// a_address
	private String aIdcard;		// 甲方身份证
	private String aPostcode;		// 甲方邮政编码
	private String aPhone;		// 甲方手机
	private String aEmail;		// 甲方email
	private String aPName;		// 甲方代理人名字
	private String aPContry;		// 甲方代理人国家
	private String aPIdcard;		// 甲方代理人身份证
	private String aPAddress;		// 甲方代理人地址
	private String aPPoscode;		// 甲方邮政编码
	private String useHd;
	private  String contractAdd;
	private String fAnjb;

	public String getFAnjb() {
		return fAnjb;
	}

	public void setFAnjb(String fAnjb) {
		this.fAnjb = fAnjb;
	}

	public String getContractAdd() {
		return contractAdd;
	}

	public void setContractAdd(String contractAdd) {
		this.contractAdd = contractAdd;
	}

	public String getUseHd() {
		return useHd;
	}

	public void setUseHd(String useHd) {
		this.useHd = useHd;
	}

	private String wfjqFy;//水电无法结清保证金

	public String getWfjqFy() {
		return wfjqFy;
	}

	public void setWfjqFy(String wfjqFy) {
		this.wfjqFy = wfjqFy;
	}

	private String hCqType;
	private String hWarrantNumber;

	public String getHWarrantNumber() {
		return hWarrantNumber;
	}

	public void setHWarrantNumber(String hWarrantNumber) {
		this.hWarrantNumber = hWarrantNumber;
	}

	public String getHCqType() {
		return hCqType;
	}

	public void setHCqType(String hCqType) {
		this.hCqType = hCqType;
	}

	private String aPPhone;		// 甲方代理人手机
	private String aPEmail;		// 甲方代理人email
	private String bName;		// 乙方名称
	private String bLegal;		// 乙方法人
	private String bContry;		// 乙方国家
	private String bIdcard;		// 乙方身份证
	private String bAddress;		// 乙方地址
	private String bPostcode;		// 乙方邮政编码
	private String bPhone;		// 乙方手机
	private String bEmail;		// 乙方email
	private String bPName;		// 乙方代理人名字
	private String bPContry;		// 乙方代理人国家
	private String bPIdcard;		// 乙方代理人身份证
	private String bPAddress;		// 乙方代理人地址
	private String bPPostcode;		// 乙方代理人邮编
	private String bPPhone;
	private String bPEmail;		// 乙方代理人邮箱
	private String aType;		// 甲方类型
	private String aCardType;		// 甲方卡类型
	private String aPCardType;		// 甲方证件类型
	private String bCardType;		// 乙证件类型
	private String bPType;		// 乙方证件类型
	private String cName;		// 丙方名字
	private String cLegal;		// 丙方法人
	private String cAddress;		// 丙方地址
	private String cPostcode;		// 丙方邮编
	private String cBusiCode;		// 丙方营业执照号
	private String cRecordNumber;		// 备案证号
	private String cPIdCard;		// 丙身份证号
	private String cBroCer;		// 经纪人资格号
	private String cPhone;		// 丙手机号码
	private String cTsPhone;		// 丙方投诉号码
	private String hAccountName;		// 房屋户名
	private String hAddress;		// 房屋地址
	private String hAllplies;		// 房屋总层数
	private String hPlie;		// 房屋所在层
	private String hUseage;		// 房屋年限
	private String hYear;		// h_year
	private String hFinish;		// 房屋竣工时间
	private String hStruts;		// 房屋结构
	private String hArea;		// 建筑面积
	private String hDecoration;		// 装修情况
	private String hOthers;		// 其他设施
	private String hYyType;		// 附属房独有还是共有
	private String hFss;		// 附属房种类
	private String hUseType;		// 附属房面积种类(使用面积/建筑面积)
		private String hUseArea;		// 附属房面积大小
	private String hOthersStatus;		// 房屋限制使用权情况说明
	private String hGzSm;		// 房屋改造情况说明
	private String hGLandholder;		// 国有土地使用权人
	private String hGWarrantNumber;		// 国有土地权证号
	private String hGLandType;		// 国有土地使用权类型
	private String hGLandOthers;		// 国有土地其他情况类型
	private String hMoneyAll;		// 房屋总价
	private String hMoneyFirst;		// 定金
	private Date hTimeSecond;		// 首付日期
	private String hMoneySecond;		// 首付价格
	private String hMoneyThird;		// 第二次支付房款
	private Date hTimeThird;		// 第二次支付时间
	private String hMoneyFour;		// 余款
	private Date hTimeFour;		// 余款时间
	private String hMoneyFive;		// 按揭余款
	private String moneyBroke;		// 未履行方每日承担
	private String moneyBrokeDay;		// 违约约定天数
	private String aManageFee;		// 卖方支付居间服务费
	private String bManageFee;		// 买方支付居间服务费
	private String bOtherFee;		// 乙方其他费用
	private String hAttached;		// 房屋附属品
	private String payWay;		// 物业管理费用付款约定(1甲2乙)
	private String cPrecent;		// 丙方违约赔偿百分比
	private String traspasoDay;		// 过户最晚时间
	private String prosecuteWay;		// 起诉单位
	private String remark;		// remark
	private Date contractDate;		// 合同生成日期
	private String otherEngagements;		// 其他约定
	private String addedvaluePart;		// 增值税承担方
	private String persontaxPart;		// 个税承担方
	private String landTax;		// 土地拨划税承担方
	private String attach;		// 附件清单
	private String jfYd;		//交付约定
	private Date jfDate;		//交付约定
	private String cPPhone;
	private String cPName;
	private String bType;




	private String jfOthers;

	public String getJfOthers() {
		return jfOthers;
	}

	public void setJfOthers(String jfOthers) {
		this.jfOthers = jfOthers;
	}

	private String aYqOneydayMoney;
	private String aWyMoney;
	private String bYqOnedayMoney;
	private String bWyMoney;
	private String gfDate;
	private String hMoneyHouse;
	private String hMoneyDecor;
	private Date hTimeFive;

	private String fczNumber;
	private String tdNumber;
	private String bdNumber;
	private String qzNumber;

	public String getQzNumber() {
		return qzNumber;
	}

	public void setQzNumber(String qzNumber) {
		this.qzNumber = qzNumber;
	}

	public String getAYqOneydayMoney() {
		return aYqOneydayMoney;
	}

	public void setAYqOneydayMoney(String aYqOneydayMoney) {
		this.aYqOneydayMoney = aYqOneydayMoney;
	}

	public String getAWyMoney() {
		return aWyMoney;
	}

	public void setAWyMoney(String aWyMoney) {
		this.aWyMoney = aWyMoney;
	}

	public String getBYqOnedayMoney() {
		return bYqOnedayMoney;
	}

	public void setBYqOnedayMoney(String bYqOnedayMoney) {
		this.bYqOnedayMoney = bYqOnedayMoney;
	}

	public String getBWyMoney() {
		return bWyMoney;
	}

	public void setBWyMoney(String bWyMoney) {
		this.bWyMoney = bWyMoney;
	}

	public String getGfDate() {
		return gfDate;
	}

	public void setGfDate(String gfDate) {
		this.gfDate = gfDate;
	}

	public String getHMoneyHouse() {
		return hMoneyHouse;
	}

	public void setHMoneyHouse(String hMoneyHouse) {
		this.hMoneyHouse = hMoneyHouse;
	}

	public String getHMoneyDecor() {
		return hMoneyDecor;
	}

	public void setHMoneyDecor(String hMoneyDecor) {
		this.hMoneyDecor = hMoneyDecor;
	}

	public Date getHTimeFive() {
		return hTimeFive;
	}

	public void setHTimeFive(Date hTimeFive) {
		this.hTimeFive = hTimeFive;
	}

	public String getFczNumber() {
		return fczNumber;
	}

	public void setFczNumber(String fczNumber) {
		this.fczNumber = fczNumber;
	}

	public String getTdNumber() {
		return tdNumber;
	}

	public void setTdNumber(String tdNumber) {
		this.tdNumber = tdNumber;
	}

	public String getBdNumber() {
		return bdNumber;
	}

	public void setBdNumber(String bdNumber) {
		this.bdNumber = bdNumber;
	}



	public String getBPPhone() {
		return bPPhone;
	}

	public void setBPPhone(String bPPhone) {
		this.bPPhone = bPPhone;
	}

	public String getBType() {
		return bType;
	}

	public void setBType(String bType) {
		this.bType = bType;
	}

	public Date getHTimeSecond() {
		return hTimeSecond;
	}

	public void setHTimeSecond(Date hTimeSecond) {
		this.hTimeSecond = hTimeSecond;
	}

	public Date getJfDate() {
		return jfDate;
	}

	public void setJfDate(Date jfDate) {
		this.jfDate = jfDate;
	}

	public Date getHTimeFour() {
		return hTimeFour;
	}

	public void setHTimeFour(Date hTimeFour) {
		this.hTimeFour = hTimeFour;
	}

	public Date getHTimeThird() {
		return hTimeThird;
	}

	public void setHTimeThird(Date hTimeThird) {
		this.hTimeThird = hTimeThird;
	}

	public Date getContractDate() {
		return contractDate;
	}

	public void setContractDate(Date contractDate) {
		this.contractDate = contractDate;
	}

	public String getHFinish() {
		return hFinish;
	}

	public void setHFinish(String hFinish) {
		this.hFinish = hFinish;
	}

	public String getCPName() {
		return cPName;
	}

	public void setCPName(String cPName) {
		this.cPName = cPName;
	}


	public String getCPPhone() {
		return cPPhone;
	}

	public void setCPPhone(String cPPHone) {
		this.cPPhone = cPPHone;
	}



	public String getJfYd() {
		return jfYd;
	}

	public void setJfYd(String jfYd) {
		this.jfYd = jfYd;
	}

	public String getLandTax() {
		return landTax;
	}

	public void setLandTax(String landTax) {
		this.landTax = landTax;
	}

	public String getOtherEngagements() {
		return otherEngagements;
	}

	public void setOtherEngagements(String otherEngagements) {
		this.otherEngagements = otherEngagements;
	}

	public String getAddedvaluePart() {
		return addedvaluePart;
	}

	public void setAddedvaluePart(String addedvaluePart) {
		this.addedvaluePart = addedvaluePart;
	}

	public String getPersontaxPart() {
		return persontaxPart;
	}

	public void setPersontaxPart(String persontaxPart) {
		this.persontaxPart = persontaxPart;
	}
//
//	@Column(name="addedvalue_part", attrName="addedvaluePart", label="增值税承担方"),
//	@Column(name="persontax_part", attrName="persontaxPart", label="个税承担方"),
//	@Column(name="land_tax", attrName="landTax", label="土地拨划税承担方"),
//	@Column(name="other_engagements", attrName="otherEngagements", label="其他约定"),

	private Employee employee;


	public Date getCreateDate_gte(){
		return sqlMap.getWhere().getValue("create_date", QueryType.GTE);
	}

	public void setCreateDate_gte(Date createDate){
		createDate = DateUtils.getOfDayFirst(createDate); // 将日期的时间改为0点0分0秒
		sqlMap.getWhere().and("create_date", QueryType.GTE, createDate);
	}

	public Date getCreateDate_lte(){
		return sqlMap.getWhere().getValue("create_date", QueryType.LTE);
	}

	public void setCreateDate_lte(Date createDate){
		createDate = DateUtils.getOfDayLast(createDate); // 将日期的时间改为23点59分59秒
		sqlMap.getWhere().and("create_date", QueryType.LTE, createDate);
	}



	public Employee getEmployee() {
		return employee;
	}

	public void setEmployee(Employee employee) {
		this.employee = employee;
	}

	public FtySelContract() {
		this(null);
	}

	public FtySelContract(String id){
		super(id);
	}

	public String getContractCode() {
		return contractCode;
	}

	public void setContractCode(String contractCode) {
		this.contractCode = contractCode;
	}


	public String getCNumber() {
		return cNumber;
	}

	public void setCNumber(String cNumber) {
		this.cNumber = cNumber;
	}


	public String getAName() {
		return aName;
	}

	public void setAName(String aName) {
		this.aName = aName;
	}


	public String getALegal() {
		return aLegal;
	}

	public void setALegal(String aLegal) {
		this.aLegal = aLegal;
	}


	public String getAContry() {
		return aContry;
	}

	public void setAContry(String aContry) {
		this.aContry = aContry;
	}


	public String getAAddress() {
		return aAddress;
	}

	public void setAAddress(String aAddress) {
		this.aAddress = aAddress;
	}


	public String getAIdcard() {
		return aIdcard;
	}

	public void setAIdcard(String aIdcard) {
		this.aIdcard = aIdcard;
	}


	public String getAPostcode() {
		return aPostcode;
	}

	public void setAPostcode(String aPostcode) {
		this.aPostcode = aPostcode;
	}


	public String getAPhone() {
		return aPhone;
	}

	public void setAPhone(String aPhone) {
		this.aPhone = aPhone;
	}


	public String getAEmail() {
		return aEmail;
	}

	public void setAEmail(String aEmail) {
		this.aEmail = aEmail;
	}


	public String getAPName() {
		return aPName;
	}

	public void setAPName(String aPName) {
		this.aPName = aPName;
	}


	public String getAPContry() {
		return aPContry;
	}

	public void setAPContry(String aPContry) {
		this.aPContry = aPContry;
	}


	public String getAPIdcard() {
		return aPIdcard;
	}

	public void setAPIdcard(String aPIdcard) {
		this.aPIdcard = aPIdcard;
	}


	public String getAPAddress() {
		return aPAddress;
	}

	public void setAPAddress(String aPAddress) {
		this.aPAddress = aPAddress;
	}


	public String getAPPoscode() {
		return aPPoscode;
	}

	public void setAPPoscode(String aPPoscode) {
		this.aPPoscode = aPPoscode;
	}


	public String getAPPhone() {
		return aPPhone;
	}

	public void setAPPhone(String aPPhone) {
		this.aPPhone = aPPhone;
	}


	public String getAPEmail() {
		return aPEmail;
	}

	public void setAPEmail(String aPEmail) {
		this.aPEmail = aPEmail;
	}


	public String getBName() {
		return bName;
	}

	public void setBName(String bName) {
		this.bName = bName;
	}


	public String getBLegal() {
		return bLegal;
	}

	public void setBLegal(String bLegal) {
		this.bLegal = bLegal;
	}


	public String getBContry() {
		return bContry;
	}

	public void setBContry(String bContry) {
		this.bContry = bContry;
	}


	public String getBIdcard() {
		return bIdcard;
	}

	public void setBIdcard(String bIdcard) {
		this.bIdcard = bIdcard;
	}


	public String getBAddress() {
		return bAddress;
	}

	public void setBAddress(String bAddress) {
		this.bAddress = bAddress;
	}


	public String getBPostcode() {
		return bPostcode;
	}

	public void setBPostcode(String bPostcode) {
		this.bPostcode = bPostcode;
	}


	public String getBPhone() {
		return bPhone;
	}

	public void setBPhone(String bPhone) {
		this.bPhone = bPhone;
	}


	public String getBEmail() {
		return bEmail;
	}

	public void setBEmail(String bEmail) {
		this.bEmail = bEmail;
	}


	public String getBPName() {
		return bPName;
	}

	public void setBPName(String bPName) {
		this.bPName = bPName;
	}


	public String getBPContry() {
		return bPContry;
	}

	public void setBPContry(String bPContry) {
		this.bPContry = bPContry;
	}


	public String getBPIdcard() {
		return bPIdcard;
	}

	public void setBPIdcard(String bPIdcard) {
		this.bPIdcard = bPIdcard;
	}


	public String getBPAddress() {
		return bPAddress;
	}

	public void setBPAddress(String bPAddress) {
		this.bPAddress = bPAddress;
	}


	public String getBPPostcode() {
		return bPPostcode;
	}

	public void setBPPostcode(String bPPostcode) {
		this.bPPostcode = bPPostcode;
	}


	public String getBPEmail() {
		return bPEmail;
	}

	public void setBPEmail(String bPEmail) {
		this.bPEmail = bPEmail;
	}


	public String getAType() {
		return aType;
	}

	public void setAType(String aType) {
		this.aType = aType;
	}


	public String getACardType() {
		return aCardType;
	}

	public void setACardType(String aCardType) {
		this.aCardType = aCardType;
	}


	public String getAPCardType() {
		return aPCardType;
	}

	public void setAPCardType(String aPCardType) {
		this.aPCardType = aPCardType;
	}


	public String getBCardType() {
		return bCardType;
	}

	public void setBCardType(String bCardType) {
		this.bCardType = bCardType;
	}


	public String getBPType() {
		return bPType;
	}

	public void setBPType(String bPType) {
		this.bPType = bPType;
	}


	public String getCName() {
		return cName;
	}

	public void setCName(String cName) {
		this.cName = cName;
	}


	public String getCLegal() {
		return cLegal;
	}

	public void setCLegal(String cLegal) {
		this.cLegal = cLegal;
	}


	public String getCAddress() {
		return cAddress;
	}

	public void setCAddress(String cAddress) {
		this.cAddress = cAddress;
	}


	public String getCPostcode() {
		return cPostcode;
	}

	public void setCPostcode(String cPostcode) {
		this.cPostcode = cPostcode;
	}


	public String getCBusiCode() {
		return cBusiCode;
	}

	public void setCBusiCode(String cBusiCode) {
		this.cBusiCode = cBusiCode;
	}


	public String getCRecordNumber() {
		return cRecordNumber;
	}

	public void setCRecordNumber(String cRecordNumber) {
		this.cRecordNumber = cRecordNumber;
	}


	public String getCPIdCard() {
		return cPIdCard;
	}

	public void setCPIdCard(String cPIdCard) {
		this.cPIdCard = cPIdCard;
	}


	public String getCBroCer() {
		return cBroCer;
	}

	public void setCBroCer(String cBroCer) {
		this.cBroCer = cBroCer;
	}


	public String getCPhone() {
		return cPhone;
	}

	public void setCPhone(String cPhone) {
		this.cPhone = cPhone;
	}


	public String getCTsPhone() {
		return cTsPhone;
	}

	public void setCTsPhone(String cTsPhone) {
		this.cTsPhone = cTsPhone;
	}


	public String getHAccountName() {
		return hAccountName;
	}

	public void setHAccountName(String hAccountName) {
		this.hAccountName = hAccountName;
	}


	public String getHAddress() {
		return hAddress;
	}

	public void setHAddress(String hAddress) {
		this.hAddress = hAddress;
	}


	public String getHAllplies() {
		return hAllplies;
	}

	public void setHAllplies(String hAllplies) {
		this.hAllplies = hAllplies;
	}


	public String getHPlie() {
		return hPlie;
	}

	public void setHPlie(String hPlie) {
		this.hPlie = hPlie;
	}


	public String getHUseage() {
		return hUseage;
	}

	public void setHUseage(String hUseage) {
		this.hUseage = hUseage;
	}


	public String getHYear() {
		return hYear;
	}

	public void setHYear(String hYear) {
		this.hYear = hYear;
	}



	public String getHStruts() {
		return hStruts;
	}

	public void setHStruts(String hStruts) {
		this.hStruts = hStruts;
	}


	public String getHArea() {
		return hArea;
	}

	public void setHArea(String hArea) {
		this.hArea = hArea;
	}


	public String getHDecoration() {
		return hDecoration;
	}

	public void setHDecoration(String hDecoration) {
		this.hDecoration = hDecoration;
	}


	public String getHOthers() {
		return hOthers;
	}

	public void setHOthers(String hOthers) {
		this.hOthers = hOthers;
	}


	public String getHYyType() {
		return hYyType;
	}

	public void setHYyType(String hYyType) {
		this.hYyType = hYyType;
	}


	public String getHFss() {
		return hFss;
	}

	public void setHFss(String hFss) {
		this.hFss = hFss;
	}


	public String getHUseType() {
		return hUseType;
	}

	public void setHUseType(String hUseType) {
		this.hUseType = hUseType;
	}


	public String getHUseArea() {
		return hUseArea;
	}

	public void setHUseArea(String hUseArea) {
		this.hUseArea = hUseArea;
	}


	public String getHOthersStatus() {
		return hOthersStatus;
	}
	public void setHOthersStatus(String hOthersStatus) {
		this.hOthersStatus = hOthersStatus;
	}


	public String getHGzSm() {
		return hGzSm;
	}

	public void setHGzSm(String hGzSm) {
		this.hGzSm = hGzSm;
	}


	public String getHGLandholder() {
		return hGLandholder;
	}

	public void setHGLandholder(String hGLandholder) {
		this.hGLandholder = hGLandholder;
	}


	public String getHGWarrantNumber() {
		return hGWarrantNumber;
	}

	public void setHGWarrantNumber(String hGWarrantNumber) {
		this.hGWarrantNumber = hGWarrantNumber;
	}


	public String getHGLandType() {
		return hGLandType;
	}

	public void setHGLandType(String hGLandType) {
		this.hGLandType = hGLandType;
	}


	public String getHGLandOthers() {
		return hGLandOthers;
	}

	public void setHGLandOthers(String hGLandOthers) {
		this.hGLandOthers = hGLandOthers;
	}


	public String getHMoneyAll() {
		return hMoneyAll;
	}

	public void setHMoneyAll(String hMoneyAll) {
		this.hMoneyAll = hMoneyAll;
	}


	public String getHMoneyFirst() {
		return hMoneyFirst;
	}

	public void setHMoneyFirst(String hMoneyFirst) {
		this.hMoneyFirst = hMoneyFirst;
	}



	public String getHMoneySecond() {
		return hMoneySecond;
	}

	public void setHMoneySecond(String hMoneySecond) {
		this.hMoneySecond = hMoneySecond;
	}


	public String getHMoneyThird() {
		return hMoneyThird;
	}

	public void setHMoneyThird(String hMoneyThird) {
		this.hMoneyThird = hMoneyThird;
	}



	public String getHMoneyFour() {
		return hMoneyFour;
	}

	public void setHMoneyFour(String hMoneyFour) {
		this.hMoneyFour = hMoneyFour;
	}



	public String getHMoneyFive() {
		return hMoneyFive;
	}

	public void setHMoneyFive(String hMoneyFive) {
		this.hMoneyFive = hMoneyFive;
	}


	public String getMoneyBroke() {
		return moneyBroke;
	}

	public void setMoneyBroke(String moneyBroke) {
		this.moneyBroke = moneyBroke;
	}


	public String getMoneyBrokeDay() {
		return moneyBrokeDay;
	}

	public void setMoneyBrokeDay(String moneyBrokeDay) {
		this.moneyBrokeDay = moneyBrokeDay;
	}


	public String getAManageFee() {
		return aManageFee;
	}

	public void setAManageFee(String aManageFee) {
		this.aManageFee = aManageFee;
	}


	public String getBManageFee() {
		return bManageFee;
	}

	public void setBManageFee(String bManageFee) {
		this.bManageFee = bManageFee;
	}


	public String getBOtherFee() {
		return bOtherFee;
	}

	public void setBOtherFee(String bOtherFee) {
		this.bOtherFee = bOtherFee;
	}


	public String getHAttached() {
		return hAttached;
	}

	public void setHAttached(String hAttached) {
		this.hAttached = hAttached;
	}


	public String getPayWay() {
		return payWay;
	}

	public void setPayWay(String payWay) {
		this.payWay = payWay;
	}


	public String getCPrecent() {
		return cPrecent;
	}

	public void setCPrecent(String cPrecent) {
		this.cPrecent = cPrecent;
	}


	public String getTraspasoDay() {
		return traspasoDay;
	}

	public void setTraspasoDay(String traspasoDay) {
		this.traspasoDay = traspasoDay;
	}


	public String getProsecuteWay() {
		return prosecuteWay;
	}

	public void setProsecuteWay(String prosecuteWay) {
		this.prosecuteWay = prosecuteWay;
	}


	public String getRemark() {
		return remark;
	}

	public void setRemark(String remark) {
		this.remark = remark;
	}


	public String getAttach() {
		return attach;
	}

	public void setAttach(String attach) {
		this.attach = attach;
	}

}